/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80402 (8.4.2)
 Source Host           : localhost:3306
 Source Schema         : DBMS

 Target Server Type    : MySQL
 Target Server Version : 80402 (8.4.2)
 File Encoding         : 65001

 Date: 14/11/2024 01:16:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bis_model_psparms
-- ----------------------------
DROP TABLE IF EXISTS `bis_model_psparms`;
CREATE TABLE `bis_model_psparms` (
  `id` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
  `nunms` int DEFAULT NULL COMMENT '参数数目',
  `ilf` decimal(4,1) DEFAULT NULL COMMENT '个体学习因子',
  `iw` decimal(2,1) DEFAULT NULL COMMENT '惯性权重',
  `iwdr` decimal(2,1) DEFAULT NULL COMMENT '惯性权重阻尼比',
  `nop` int DEFAULT NULL COMMENT '粒子群数目',
  `glf` int DEFAULT NULL COMMENT '群体学习因子',
  `mni` int DEFAULT NULL COMMENT '最大迭代次数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='粒子群参数表';

-- ----------------------------
-- Records of bis_model_psparms
-- ----------------------------
BEGIN;
INSERT INTO `bis_model_psparms` (`id`, `nunms`, `ilf`, `iw`, `iwdr`, `nop`, `glf`, `mni`) VALUES ('113303744883593216', 3, 3.0, 3.0, 4.0, 5, 6, 7);
COMMIT;

-- ----------------------------
-- Table structure for bis_referenced_data
-- ----------------------------
DROP TABLE IF EXISTS `bis_referenced_data`;
CREATE TABLE `bis_referenced_data` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `zfxl` double(22,3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of bis_referenced_data
-- ----------------------------
BEGIN;
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (1, 0.058);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (2, 0.052);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (3, 0.051);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (4, 0.042);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (5, 0.047);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (6, 0.050);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (7, 0.032);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (8, 0.035);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (9, 0.035);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (10, 0.047);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (11, 0.062);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (12, 0.066);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (13, 0.078);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (14, 0.070);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (15, 0.081);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (16, 0.084);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (17, 0.078);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (18, 0.067);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (19, 0.076);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (20, 0.065);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (21, 0.071);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (22, 0.070);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (23, 0.067);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (24, 0.079);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (25, 0.079);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (26, 0.088);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (27, 0.065);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (28, 0.067);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (29, 0.080);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (30, 0.061);
INSERT INTO `bis_referenced_data` (`id`, `zfxl`) VALUES (31, 0.075);
COMMIT;

-- ----------------------------
-- Table structure for bis_xajmode_paras
-- ----------------------------
DROP TABLE IF EXISTS `bis_xajmode_paras`;
CREATE TABLE `bis_xajmode_paras` (
  `id` char(64) NOT NULL COMMENT '主键',
  `rcode` int DEFAULT NULL COMMENT '河道编码',
  `rnname` char(128) DEFAULT NULL COMMENT '河道名称',
  `stname` char(128) DEFAULT NULL COMMENT '控制面站名',
  `stcd` char(128) DEFAULT NULL COMMENT '控制面站码',
  `zsfxxs_m` decimal(2,1) DEFAULT NULL COMMENT '蒸散发折算系数最大值',
  `zsfxxs_s` decimal(2,1) DEFAULT NULL COMMENT '蒸散发折算系数最小值',
  `zsfxxs` decimal(2,1) DEFAULT NULL COMMENT '蒸散发折算系数率定值',
  `zysrl_m` int DEFAULT NULL COMMENT '自由水容量最大值',
  `zysrl_s` int DEFAULT NULL COMMENT '自由水容量最小值',
  `zysrl` int DEFAULT NULL COMMENT '自由水容量率定值',
  `ugo_m` decimal(2,1) DEFAULT NULL COMMENT '地下水出流系数最大值',
  `ugo_s` decimal(2,1) DEFAULT NULL COMMENT '地下水出流系数最小值',
  `ugo` decimal(2,1) DEFAULT NULL COMMENT '地下水出流系数率定值',
  `ogf_m` decimal(2,1) DEFAULT NULL COMMENT '地下水消退系数最大值',
  `ogf_s` decimal(2,1) DEFAULT NULL COMMENT '地下水消退系数最小值',
  `ogf` decimal(2,1) DEFAULT NULL COMMENT '地下水消退系数率定值',
  `rcfs_m` decimal(2,1) DEFAULT NULL COMMENT '壤中流消退系数最大值',
  `rcfs_s` decimal(2,1) DEFAULT NULL COMMENT '壤中流消退系数最小值',
  `rcfs` decimal(2,1) DEFAULT NULL COMMENT '壤中流消退系数率定值',
  `rcfr_m` decimal(2,1) DEFAULT NULL COMMENT '河网水流消退系数最最大值',
  `rcfr_s` decimal(2,1) DEFAULT NULL COMMENT '河网水流消退系数最小值',
  `rcfr` decimal(2,1) DEFAULT NULL COMMENT '河网水流消退系数率定值',
  `ctw_m` int DEFAULT NULL COMMENT '张力水容量最大值',
  `ctw_s` int DEFAULT NULL COMMENT '张力水容量最小值',
  `ctw` int DEFAULT NULL COMMENT '张力水容量率定值',
  `uctw_m` int DEFAULT NULL COMMENT '上层张力水容量最大值',
  `uctw_s` int DEFAULT NULL COMMENT '上层张力水容量最小值',
  `uctw` int DEFAULT NULL COMMENT '上层张力水容量率定值',
  `cltw_m` int DEFAULT NULL COMMENT '下层张力水容量最大值',
  `cltw_s` int DEFAULT NULL COMMENT '下层张力水容量最小值',
  `cltw` int DEFAULT NULL COMMENT '下层张力水容量率定值',
  `dec_m` decimal(2,1) DEFAULT NULL COMMENT '深层蒸散发系数最大值',
  `dec_s` decimal(2,1) DEFAULT NULL COMMENT '深层蒸散发系数最小值',
  `dec` decimal(2,1) DEFAULT NULL COMMENT '深层蒸散发系数率定值',
  `dcsc_m` decimal(2,1) DEFAULT NULL COMMENT '流域蓄水容量分布曲线指数最大值',
  `dcsc_s` decimal(2,1) DEFAULT NULL COMMENT '流域蓄水容量分布曲线指数最小值',
  `dcsc` decimal(2,1) DEFAULT NULL COMMENT '流域蓄水容量分布曲线指数率定值',
  `fcdc_m` decimal(2,1) DEFAULT NULL COMMENT '流域自由水容量分布曲线指数最大值',
  `fcdc_s` decimal(2,1) DEFAULT NULL COMMENT '流域自由水容量分布曲线指数最小值',
  `fcdc` decimal(2,1) DEFAULT NULL COMMENT '流域自由水容量分布曲线指数率定值',
  `pia_m` decimal(2,1) DEFAULT NULL COMMENT '不透水面积比例最大值',
  `pia_s` decimal(2,1) DEFAULT NULL COMMENT '不透水面积比例最小值',
  `pia` decimal(2,1) DEFAULT NULL COMMENT '不透水面积比例率定值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='模型参数表';

-- ----------------------------
-- Records of bis_xajmode_paras
-- ----------------------------
BEGIN;
INSERT INTO `bis_xajmode_paras` (`id`, `rcode`, `rnname`, `stname`, `stcd`, `zsfxxs_m`, `zsfxxs_s`, `zsfxxs`, `zysrl_m`, `zysrl_s`, `zysrl`, `ugo_m`, `ugo_s`, `ugo`, `ogf_m`, `ogf_s`, `ogf`, `rcfs_m`, `rcfs_s`, `rcfs`, `rcfr_m`, `rcfr_s`, `rcfr`, `ctw_m`, `ctw_s`, `ctw`, `uctw_m`, `uctw_s`, `uctw`, `cltw_m`, `cltw_s`, `cltw`, `dec_m`, `dec_s`, `dec`, `dcsc_m`, `dcsc_s`, `dcsc`, `fcdc_m`, `fcdc_s`, `fcdc`, `pia_m`, `pia_s`, `pia`) VALUES ('114043712337743872', 6, '宋江河', '罗场', '605HQ014', 1.0, 2.0, 3.0, 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.0, 1.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0);
COMMIT;

-- ----------------------------
-- Table structure for bis_xajmodel_arearate
-- ----------------------------
DROP TABLE IF EXISTS `bis_xajmodel_arearate`;
CREATE TABLE `bis_xajmodel_arearate` (
  `id` char(64) NOT NULL COMMENT '主键',
  `stcd_r` char(64) DEFAULT NULL COMMENT '控制面(站编码)',
  `stcd_rn` char(128) DEFAULT NULL COMMENT '控制面',
  `num` int DEFAULT NULL COMMENT '序号',
  `stcd_p` char(64) DEFAULT NULL COMMENT '雨量站编码',
  `stcd_pn` char(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '雨量站名称',
  `areas` decimal(12,3) DEFAULT NULL COMMENT '面积',
  `rate` decimal(5,4) DEFAULT NULL COMMENT '面积比',
  `lhcsd` int DEFAULT NULL COMMENT '马法演算段数（日）',
  `lhcs` int DEFAULT NULL COMMENT '马法演算段数（次）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='河流参数表';

-- ----------------------------
-- Records of bis_xajmodel_arearate
-- ----------------------------
BEGIN;
INSERT INTO `bis_xajmodel_arearate` (`id`, `stcd_r`, `stcd_rn`, `num`, `stcd_p`, `stcd_pn`, `areas`, `rate`, `lhcsd`, `lhcs`) VALUES ('1', '605HQ014', '', 1, '605HQ003', '塘坝', 64.084, 0.1300, 11, 11);
INSERT INTO `bis_xajmodel_arearate` (`id`, `stcd_r`, `stcd_rn`, `num`, `stcd_p`, `stcd_pn`, `areas`, `rate`, `lhcsd`, `lhcs`) VALUES ('114749016373334016', '605HQ014', '', 2, '6055Q095', '双滕', 71.723, 0.1462, 0, 0);
INSERT INTO `bis_xajmodel_arearate` (`id`, `stcd_r`, `stcd_rn`, `num`, `stcd_p`, `stcd_pn`, `areas`, `rate`, `lhcsd`, `lhcs`) VALUES ('4', '605HQ014', '罗场', 4, '6055Q096', '木映', 61.517, 0.1254, 0, 2);
INSERT INTO `bis_xajmodel_arearate` (`id`, `stcd_r`, `stcd_rn`, `num`, `stcd_p`, `stcd_pn`, `areas`, `rate`, `lhcsd`, `lhcs`) VALUES ('5', '605HQ014', '罗场', 5, '6055Q052', '羊田', 30.697, 0.0626, 0, 1);
INSERT INTO `bis_xajmodel_arearate` (`id`, `stcd_r`, `stcd_rn`, `num`, `stcd_p`, `stcd_pn`, `areas`, `rate`, `lhcsd`, `lhcs`) VALUES ('6', '605HQ014', '罗场', 6, '6055Q041', '陈村', 86.325, 0.1759, 0, 3);
INSERT INTO `bis_xajmodel_arearate` (`id`, `stcd_r`, `stcd_rn`, `num`, `stcd_p`, `stcd_pn`, `areas`, `rate`, `lhcsd`, `lhcs`) VALUES ('7', '605HQ014', '罗场', 7, '6055Q092', '前丰', 55.745, 0.1136, 0, 2);
COMMIT;

-- ----------------------------
-- Table structure for bis_xnjmode_project
-- ----------------------------
DROP TABLE IF EXISTS `bis_xnjmode_project`;
CREATE TABLE `bis_xnjmode_project` (
  `id` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
  `rcode` char(64) DEFAULT NULL COMMENT '河流编码',
  `pname` char(128) DEFAULT NULL COMMENT '方案名称',
  `stcd_r` char(64) DEFAULT NULL COMMENT '控制点（站）',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `pstart_time` datetime DEFAULT NULL COMMENT '方案开始时间',
  `pend_time` datetime DEFAULT NULL COMMENT '方案结束时间',
  `parms` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '输入参数json',
  `rstart_time` datetime DEFAULT NULL COMMENT '运行开始时间',
  `rend_time` datetime DEFAULT NULL COMMENT '运行结束时间',
  `max_q` decimal(12,2) DEFAULT NULL COMMENT '控制点最大流量',
  `max_q_time` datetime DEFAULT NULL COMMENT '控制点最大流量时间',
  `result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '模型返回参数json',
  `stct_r_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '控制点时间流量json',
  `create_person` char(64) DEFAULT NULL COMMENT '创建人',
  `status` int DEFAULT NULL COMMENT '状态（0：编制完成1：运行中 2：运行完成  3：终止）',
  `setting` int DEFAULT NULL COMMENT '操作记录 1 率定 2 计算',
  `is_type` int DEFAULT NULL COMMENT '1 普通模式  2 自定义模式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='降雨运行方案';

-- ----------------------------
-- Records of bis_xnjmode_project
-- ----------------------------
BEGIN;
INSERT INTO `bis_xnjmode_project` (`id`, `rcode`, `pname`, `stcd_r`, `create_date`, `pstart_time`, `pend_time`, `parms`, `rstart_time`, `rend_time`, `max_q`, `max_q_time`, `result`, `stct_r_json`, `create_person`, `status`, `setting`, `is_type`) VALUES ('6605HQ0141731516791970', 'sjh', '测试大模型1', '605HQ014', '2024-11-14 00:53:12', '2024-07-16 00:00:00', '2024-07-16 04:00:00', '{\"id\":\"6605HQ0141731516791970\",\"name\":\"测试大模型1\",\"start-time\":\"2024-07-16 00:00:00\",\"end-time\":\"2024-07-16 04:00:00\",\"callback\":\"19ew776533.imwork.net/dbms/call_back/callback\",\"step-len\":\"60\",\"model\":1,\"xajpara\":{\"zsfxxs\":{\"max\":1.0,\"min\":2.0,\"rate\":3.0},\"zysrl\":{\"max\":0,\"min\":0,\"rate\":0},\"ugo\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ogf\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfs\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfr\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ctw\":{\"max\":0,\"min\":0,\"rate\":0},\"uctw\":{\"max\":0,\"min\":0,\"rate\":0},\"cltw\":{\"max\":0,\"min\":0,\"rate\":0},\"dec\":{\"max\":1.0,\"min\":1.0,\"rate\":0.0},\"dcsc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"fcdc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"pia\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0}},\"psparms\":{\"nunms\":3,\"ilf\":3.0,\"iw\":3.0,\"iwdr\":4.0,\"nop\":5,\"glf\":6,\"mni\":7},\"areainfo\":[{\"id\":1,\"stcd\":\"605HQ014\",\"name\":\"塘坝\",\"areas\":64.084,\"rate\":0.1300,\"lhcsd\":11,\"lhcs\":11},{\"id\":2,\"stcd\":\"605HQ014\",\"name\":\"双滕\",\"areas\":71.723,\"rate\":0.1462,\"lhcsd\":0,\"lhcs\":0},{\"id\":4,\"stcd\":\"605HQ014\",\"name\":\"木映\",\"areas\":61.517,\"rate\":0.1254,\"lhcsd\":0,\"lhcs\":2},{\"id\":5,\"stcd\":\"605HQ014\",\"name\":\"羊田\",\"areas\":30.697,\"rate\":0.0626,\"lhcsd\":0,\"lhcs\":1},{\"id\":6,\"stcd\":\"605HQ014\",\"name\":\"陈村\",\"areas\":86.325,\"rate\":0.1759,\"lhcsd\":0,\"lhcs\":3},{\"id\":7,\"stcd\":\"605HQ014\",\"name\":\"前丰\",\"areas\":55.745,\"rate\":0.1136,\"lhcsd\":0,\"lhcs\":2}],\"rains\":[{\"time\":\"2024-07-16 00:00:00\",\"mq\":2760.000,\"erate\":0.035,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 01:00:00\",\"mq\":2780.000,\"erate\":0.052,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 02:00:00\",\"mq\":2810.000,\"erate\":0.052,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 03:00:00\",\"mq\":2820.000,\"erate\":0.035,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 04:00:00\",\"mq\":2830.000,\"erate\":0.088,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]}]}', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1);
INSERT INTO `bis_xnjmode_project` (`id`, `rcode`, `pname`, `stcd_r`, `create_date`, `pstart_time`, `pend_time`, `parms`, `rstart_time`, `rend_time`, `max_q`, `max_q_time`, `result`, `stct_r_json`, `create_person`, `status`, `setting`, `is_type`) VALUES ('6605HQ0141731516901867', 'sjh', '测试大模型2', '605HQ014', '2024-11-14 00:55:02', '2024-07-16 00:00:00', '2024-07-16 04:00:00', '{\"id\":\"6605HQ0141731516901867\",\"name\":\"测试大模型2\",\"start-time\":\"2024-07-16 00:00:00\",\"end-time\":\"2024-07-16 04:00:00\",\"callback\":\"19ew776533.imwork.net/dbms/call_back/callback\",\"step-len\":\"60\",\"model\":1,\"xajpara\":{\"zsfxxs\":{\"max\":1.0,\"min\":2.0,\"rate\":3.0},\"zysrl\":{\"max\":0,\"min\":0,\"rate\":0},\"ugo\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ogf\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfs\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfr\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ctw\":{\"max\":0,\"min\":0,\"rate\":0},\"uctw\":{\"max\":0,\"min\":0,\"rate\":0},\"cltw\":{\"max\":0,\"min\":0,\"rate\":0},\"dec\":{\"max\":1.0,\"min\":1.0,\"rate\":0.0},\"dcsc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"fcdc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"pia\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0}},\"psparms\":{\"nunms\":3,\"ilf\":3.0,\"iw\":3.0,\"iwdr\":4.0,\"nop\":5,\"glf\":6,\"mni\":7},\"areainfo\":[{\"id\":1,\"stcd\":\"605HQ014\",\"name\":\"塘坝\",\"areas\":64.084,\"rate\":0.1300,\"lhcsd\":11,\"lhcs\":11},{\"id\":2,\"stcd\":\"605HQ014\",\"name\":\"双滕\",\"areas\":71.723,\"rate\":0.1462,\"lhcsd\":0,\"lhcs\":0},{\"id\":4,\"stcd\":\"605HQ014\",\"name\":\"木映\",\"areas\":61.517,\"rate\":0.1254,\"lhcsd\":0,\"lhcs\":2},{\"id\":5,\"stcd\":\"605HQ014\",\"name\":\"羊田\",\"areas\":30.697,\"rate\":0.0626,\"lhcsd\":0,\"lhcs\":1},{\"id\":6,\"stcd\":\"605HQ014\",\"name\":\"陈村\",\"areas\":86.325,\"rate\":0.1759,\"lhcsd\":0,\"lhcs\":3},{\"id\":7,\"stcd\":\"605HQ014\",\"name\":\"前丰\",\"areas\":55.745,\"rate\":0.1136,\"lhcsd\":0,\"lhcs\":2}],\"rains\":[{\"time\":\"2024-07-16 00:00:00\",\"mq\":2760.000,\"erate\":0.047,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 01:00:00\",\"mq\":2780.000,\"erate\":0.047,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 02:00:00\",\"mq\":2810.000,\"erate\":0.067,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 03:00:00\",\"mq\":2820.000,\"erate\":0.051,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 04:00:00\",\"mq\":2830.000,\"erate\":0.075,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]}]}', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1);
INSERT INTO `bis_xnjmode_project` (`id`, `rcode`, `pname`, `stcd_r`, `create_date`, `pstart_time`, `pend_time`, `parms`, `rstart_time`, `rend_time`, `max_q`, `max_q_time`, `result`, `stct_r_json`, `create_person`, `status`, `setting`, `is_type`) VALUES ('6605HQ0141731516937256', 'sjh', '测试自定大模型', '605HQ014', '2024-11-14 00:55:37', '2024-07-16 00:00:00', '2024-07-16 04:00:00', '{\"id\":\"6605HQ0141731516937256\",\"name\":\"测试自定大模型\",\"start-time\":\"2024-07-16 00:00:00\",\"end-time\":\"2024-07-16 04:00:00\",\"callback\":\"19ew776533.imwork.net/dbms/call_back/callback\",\"step-len\":\"60\",\"model\":2,\"xajpara\":{\"zsfxxs\":{\"max\":1.0,\"min\":2.0,\"rate\":3.0},\"zysrl\":{\"max\":0,\"min\":0,\"rate\":0},\"ugo\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ogf\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfs\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfr\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ctw\":{\"max\":0,\"min\":0,\"rate\":0},\"uctw\":{\"max\":0,\"min\":0,\"rate\":0},\"cltw\":{\"max\":0,\"min\":0,\"rate\":0},\"dec\":{\"max\":1.0,\"min\":1.0,\"rate\":0.0},\"dcsc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"fcdc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"pia\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0}},\"psparms\":{\"nunms\":3,\"ilf\":3.0,\"iw\":3.0,\"iwdr\":4.0,\"nop\":5,\"glf\":6,\"mni\":7},\"areainfo\":[{\"id\":1,\"stcd\":\"605HQ014\",\"name\":\"塘坝\",\"areas\":64.084,\"rate\":0.1300,\"lhcsd\":11,\"lhcs\":11},{\"id\":2,\"stcd\":\"605HQ014\",\"name\":\"双滕\",\"areas\":71.723,\"rate\":0.1462,\"lhcsd\":0,\"lhcs\":0},{\"id\":4,\"stcd\":\"605HQ014\",\"name\":\"木映\",\"areas\":61.517,\"rate\":0.1254,\"lhcsd\":0,\"lhcs\":2},{\"id\":5,\"stcd\":\"605HQ014\",\"name\":\"羊田\",\"areas\":30.697,\"rate\":0.0626,\"lhcsd\":0,\"lhcs\":1},{\"id\":6,\"stcd\":\"605HQ014\",\"name\":\"陈村\",\"areas\":86.325,\"rate\":0.1759,\"lhcsd\":0,\"lhcs\":3},{\"id\":7,\"stcd\":\"605HQ014\",\"name\":\"前丰\",\"areas\":55.745,\"rate\":0.1136,\"lhcsd\":0,\"lhcs\":2}],\"rains\":[{\"erate\":\"0.08\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"1.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.5\",\"stcd\":\"蒸发\"},{\"drp\":\"0.5\",\"stcd\":\"孔花\"},{\"drp\":\"0.6\",\"stcd\":\"王家\"},{\"drp\":\"0.7\",\"stcd\":\"花田\"},{\"drp\":\"0.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 00:00:00\"},{\"erate\":\"0.08\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"1.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.0\",\"stcd\":\"蒸发\"},{\"drp\":\"1.5\",\"stcd\":\"孔花\"},{\"drp\":\"1.6\",\"stcd\":\"王家\"},{\"drp\":\"1.7\",\"stcd\":\"花田\"},{\"drp\":\"1.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 01:00:00\"},{\"erate\":\"0.05\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"2.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.0\",\"stcd\":\"蒸发\"},{\"drp\":\"2.5\",\"stcd\":\"孔花\"},{\"drp\":\"2.6\",\"stcd\":\"王家\"},{\"drp\":\"2.7\",\"stcd\":\"花田\"},{\"drp\":\"2.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 02:00:00\"},{\"erate\":\"0.07\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"3.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.0\",\"stcd\":\"蒸发\"},{\"drp\":\"3.5\",\"stcd\":\"孔花\"},{\"drp\":\"3.6\",\"stcd\":\"王家\"},{\"drp\":\"3.7\",\"stcd\":\"花田\"},{\"drp\":\"3.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 04:00:00\"}]}', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 2);
INSERT INTO `bis_xnjmode_project` (`id`, `rcode`, `pname`, `stcd_r`, `create_date`, `pstart_time`, `pend_time`, `parms`, `rstart_time`, `rend_time`, `max_q`, `max_q_time`, `result`, `stct_r_json`, `create_person`, `status`, `setting`, `is_type`) VALUES ('6605HQ0141731516966166', 'sjh', '测试自定大模型1', '605HQ014', '2024-11-14 00:56:06', '2024-07-16 00:00:00', '2024-07-16 04:00:00', '{\"id\":\"6605HQ0141731516966166\",\"name\":\"测试自定大模型1\",\"start-time\":\"2024-07-16 00:00:00\",\"end-time\":\"2024-07-16 04:00:00\",\"callback\":\"19ew776533.imwork.net/dbms/call_back/callback\",\"step-len\":\"60\",\"model\":2,\"xajpara\":{\"zsfxxs\":{\"max\":1.0,\"min\":2.0,\"rate\":3.0},\"zysrl\":{\"max\":0,\"min\":0,\"rate\":0},\"ugo\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ogf\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfs\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfr\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ctw\":{\"max\":0,\"min\":0,\"rate\":0},\"uctw\":{\"max\":0,\"min\":0,\"rate\":0},\"cltw\":{\"max\":0,\"min\":0,\"rate\":0},\"dec\":{\"max\":1.0,\"min\":1.0,\"rate\":0.0},\"dcsc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"fcdc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"pia\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0}},\"psparms\":{\"nunms\":3,\"ilf\":3.0,\"iw\":3.0,\"iwdr\":4.0,\"nop\":5,\"glf\":6,\"mni\":7},\"areainfo\":[{\"id\":1,\"stcd\":\"605HQ014\",\"name\":\"塘坝\",\"areas\":64.084,\"rate\":0.1300,\"lhcsd\":11,\"lhcs\":11},{\"id\":2,\"stcd\":\"605HQ014\",\"name\":\"双滕\",\"areas\":71.723,\"rate\":0.1462,\"lhcsd\":0,\"lhcs\":0},{\"id\":4,\"stcd\":\"605HQ014\",\"name\":\"木映\",\"areas\":61.517,\"rate\":0.1254,\"lhcsd\":0,\"lhcs\":2},{\"id\":5,\"stcd\":\"605HQ014\",\"name\":\"羊田\",\"areas\":30.697,\"rate\":0.0626,\"lhcsd\":0,\"lhcs\":1},{\"id\":6,\"stcd\":\"605HQ014\",\"name\":\"陈村\",\"areas\":86.325,\"rate\":0.1759,\"lhcsd\":0,\"lhcs\":3},{\"id\":7,\"stcd\":\"605HQ014\",\"name\":\"前丰\",\"areas\":55.745,\"rate\":0.1136,\"lhcsd\":0,\"lhcs\":2}],\"rains\":[{\"erate\":\"0.08\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"1.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.5\",\"stcd\":\"蒸发\"},{\"drp\":\"0.5\",\"stcd\":\"孔花\"},{\"drp\":\"0.6\",\"stcd\":\"王家\"},{\"drp\":\"0.7\",\"stcd\":\"花田\"},{\"drp\":\"0.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 00:00:00\"},{\"erate\":\"0.08\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"1.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.0\",\"stcd\":\"蒸发\"},{\"drp\":\"1.5\",\"stcd\":\"孔花\"},{\"drp\":\"1.6\",\"stcd\":\"王家\"},{\"drp\":\"1.7\",\"stcd\":\"花田\"},{\"drp\":\"1.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 01:00:00\"},{\"erate\":\"0.05\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"2.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.0\",\"stcd\":\"蒸发\"},{\"drp\":\"2.5\",\"stcd\":\"孔花\"},{\"drp\":\"2.6\",\"stcd\":\"王家\"},{\"drp\":\"2.7\",\"stcd\":\"花田\"},{\"drp\":\"2.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 02:00:00\"},{\"erate\":\"0.07\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"3.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.0\",\"stcd\":\"蒸发\"},{\"drp\":\"3.5\",\"stcd\":\"孔花\"},{\"drp\":\"3.6\",\"stcd\":\"王家\"},{\"drp\":\"3.7\",\"stcd\":\"花田\"},{\"drp\":\"3.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 04:00:00\"}]}', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 2);
INSERT INTO `bis_xnjmode_project` (`id`, `rcode`, `pname`, `stcd_r`, `create_date`, `pstart_time`, `pend_time`, `parms`, `rstart_time`, `rend_time`, `max_q`, `max_q_time`, `result`, `stct_r_json`, `create_person`, `status`, `setting`, `is_type`) VALUES ('6605HQ0141731517229636', 'sjh', '测试自定大模型2', '605HQ014', '2024-11-14 01:00:30', '2024-06-28 00:00:00', '2024-06-28 04:00:00', '{\"id\":\"6605HQ0141731517229636\",\"name\":\"测试自定大模型2\",\"start-time\":\"2024-07-16 00:00:00\",\"end-time\":\"2024-07-16 04:00:00\",\"callback\":\"19ew776533.imwork.net/dbms/call_back/callback\",\"step-len\":\"60\",\"model\":2,\"xajpara\":{\"zsfxxs\":{\"max\":1.0,\"min\":2.0,\"rate\":3.0},\"zysrl\":{\"max\":0,\"min\":0,\"rate\":0},\"ugo\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ogf\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfs\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfr\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ctw\":{\"max\":0,\"min\":0,\"rate\":0},\"uctw\":{\"max\":0,\"min\":0,\"rate\":0},\"cltw\":{\"max\":0,\"min\":0,\"rate\":0},\"dec\":{\"max\":1.0,\"min\":1.0,\"rate\":0.0},\"dcsc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"fcdc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"pia\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0}},\"psparms\":{\"nunms\":3,\"ilf\":3.0,\"iw\":3.0,\"iwdr\":4.0,\"nop\":5,\"glf\":6,\"mni\":7},\"areainfo\":[{\"id\":1,\"stcd\":\"605HQ014\",\"name\":\"塘坝\",\"areas\":64.084,\"rate\":0.1300,\"lhcsd\":11,\"lhcs\":11},{\"id\":2,\"stcd\":\"605HQ014\",\"name\":\"双滕\",\"areas\":71.723,\"rate\":0.1462,\"lhcsd\":0,\"lhcs\":0},{\"id\":4,\"stcd\":\"605HQ014\",\"name\":\"木映\",\"areas\":61.517,\"rate\":0.1254,\"lhcsd\":0,\"lhcs\":2},{\"id\":5,\"stcd\":\"605HQ014\",\"name\":\"羊田\",\"areas\":30.697,\"rate\":0.0626,\"lhcsd\":0,\"lhcs\":1},{\"id\":6,\"stcd\":\"605HQ014\",\"name\":\"陈村\",\"areas\":86.325,\"rate\":0.1759,\"lhcsd\":0,\"lhcs\":3},{\"id\":7,\"stcd\":\"605HQ014\",\"name\":\"前丰\",\"areas\":55.745,\"rate\":0.1136,\"lhcsd\":0,\"lhcs\":2}],\"rains\":[{\"erate\":\"0.08\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"1.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.5\",\"stcd\":\"蒸发\"},{\"drp\":\"0.5\",\"stcd\":\"孔花\"},{\"drp\":\"0.6\",\"stcd\":\"王家\"},{\"drp\":\"0.7\",\"stcd\":\"花田\"},{\"drp\":\"0.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 00:00:00\"},{\"erate\":\"0.08\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"1.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.0\",\"stcd\":\"蒸发\"},{\"drp\":\"1.5\",\"stcd\":\"孔花\"},{\"drp\":\"1.6\",\"stcd\":\"王家\"},{\"drp\":\"1.7\",\"stcd\":\"花田\"},{\"drp\":\"1.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 01:00:00\"},{\"erate\":\"0.05\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"2.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.0\",\"stcd\":\"蒸发\"},{\"drp\":\"2.5\",\"stcd\":\"孔花\"},{\"drp\":\"2.6\",\"stcd\":\"王家\"},{\"drp\":\"2.7\",\"stcd\":\"花田\"},{\"drp\":\"2.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 02:00:00\"},{\"erate\":\"0.07\",\"mq\":\"0\",\"stcdinfo\":[{\"drp\":\"3.74\",\"stcd\":\"实测流量\"},{\"drp\":\"0.0\",\"stcd\":\"蒸发\"},{\"drp\":\"3.5\",\"stcd\":\"孔花\"},{\"drp\":\"3.6\",\"stcd\":\"王家\"},{\"drp\":\"3.7\",\"stcd\":\"花田\"},{\"drp\":\"3.8\",\"stcd\":\"滥田坝\"}],\"time\":\"2024-06-28 04:00:00\"}]}', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 2);
INSERT INTO `bis_xnjmode_project` (`id`, `rcode`, `pname`, `stcd_r`, `create_date`, `pstart_time`, `pend_time`, `parms`, `rstart_time`, `rend_time`, `max_q`, `max_q_time`, `result`, `stct_r_json`, `create_person`, `status`, `setting`, `is_type`) VALUES ('6605HQ0141731517572414', 'sjh', '测试大模型3', '605HQ014', '2024-11-14 01:06:12', '2024-07-16 00:00:00', '2024-07-16 15:00:00', '{\"id\":\"6605HQ0141731517572414\",\"name\":\"测试大模型3\",\"start-time\":\"2024-07-16 00:00:00\",\"end-time\":\"2024-07-16 15:00:00\",\"callback\":\"19ew776533.imwork.net/dbms/call_back/callback\",\"step-len\":\"60\",\"model\":1,\"xajpara\":{\"zsfxxs\":{\"max\":1.0,\"min\":2.0,\"rate\":3.0},\"zysrl\":{\"max\":0,\"min\":0,\"rate\":0},\"ugo\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ogf\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfs\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"rcfr\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"ctw\":{\"max\":0,\"min\":0,\"rate\":0},\"uctw\":{\"max\":0,\"min\":0,\"rate\":0},\"cltw\":{\"max\":0,\"min\":0,\"rate\":0},\"dec\":{\"max\":1.0,\"min\":1.0,\"rate\":0.0},\"dcsc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"fcdc\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0},\"pia\":{\"max\":0.0,\"min\":0.0,\"rate\":0.0}},\"psparms\":{\"nunms\":3,\"ilf\":3.0,\"iw\":3.0,\"iwdr\":4.0,\"nop\":5,\"glf\":6,\"mni\":7},\"areainfo\":[{\"id\":1,\"stcd\":\"605HQ014\",\"name\":\"塘坝\",\"areas\":64.084,\"rate\":0.1300,\"lhcsd\":11,\"lhcs\":11},{\"id\":2,\"stcd\":\"605HQ014\",\"name\":\"双滕\",\"areas\":71.723,\"rate\":0.1462,\"lhcsd\":0,\"lhcs\":0},{\"id\":4,\"stcd\":\"605HQ014\",\"name\":\"木映\",\"areas\":61.517,\"rate\":0.1254,\"lhcsd\":0,\"lhcs\":2},{\"id\":5,\"stcd\":\"605HQ014\",\"name\":\"羊田\",\"areas\":30.697,\"rate\":0.0626,\"lhcsd\":0,\"lhcs\":1},{\"id\":6,\"stcd\":\"605HQ014\",\"name\":\"陈村\",\"areas\":86.325,\"rate\":0.1759,\"lhcsd\":0,\"lhcs\":3},{\"id\":7,\"stcd\":\"605HQ014\",\"name\":\"前丰\",\"areas\":55.745,\"rate\":0.1136,\"lhcsd\":0,\"lhcs\":2}],\"rains\":[{\"time\":\"2024-07-16 00:00:00\",\"mq\":2760.000,\"erate\":0.067,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 01:00:00\",\"mq\":2780.000,\"erate\":0.067,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 02:00:00\",\"mq\":2810.000,\"erate\":0.035,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 03:00:00\",\"mq\":2820.000,\"erate\":0.065,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 04:00:00\",\"mq\":2830.000,\"erate\":0.065,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 05:00:00\",\"mq\":2840.000,\"erate\":0.079,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 06:00:00\",\"mq\":2800.000,\"erate\":0.061,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 07:00:00\",\"mq\":2850.000,\"erate\":0.088,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 08:00:00\",\"mq\":2860.000,\"erate\":0.032,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 09:00:00\",\"mq\":2850.000,\"erate\":0.084,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 10:00:00\",\"mq\":2800.000,\"erate\":0.08,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 11:00:00\",\"mq\":2870.000,\"erate\":0.067,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 12:00:00\",\"mq\":2810.000,\"erate\":0.076,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 13:00:00\",\"mq\":2760.000,\"erate\":0.067,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 14:00:00\",\"mq\":2780.000,\"erate\":0.078,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]},{\"time\":\"2024-07-16 15:00:00\",\"mq\":2800.000,\"erate\":0.081,\"stcdinfo\":[{\"stcd\":\"605HQ014\",\"drp\":0.0}]}]}', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for bis_xnjmode_project2
-- ----------------------------
DROP TABLE IF EXISTS `bis_xnjmode_project2`;
CREATE TABLE `bis_xnjmode_project2` (
  `id` char(64) DEFAULT NULL COMMENT '主键',
  `rcode` char(64) DEFAULT NULL COMMENT '河流编码',
  `pname` char(128) DEFAULT NULL COMMENT '方案名称',
  `stcd_r` char(64) DEFAULT NULL COMMENT '控制点（站）',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `pstart_time` datetime DEFAULT NULL COMMENT '方案开始时间',
  `pend_time` datetime DEFAULT NULL COMMENT '方案结束时间',
  `parms` longtext COMMENT '输入参数json',
  `rstart_time` datetime DEFAULT NULL COMMENT '运行开始时间',
  `rend_time` datetime DEFAULT NULL COMMENT '运行结束时间',
  `max_q` decimal(12,2) DEFAULT NULL COMMENT '控制点最大流量',
  `max_q_time` datetime DEFAULT NULL COMMENT '控制点最大流量时间',
  `result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '模型返回参数json',
  `stct_r_json` longtext COMMENT '控制点时间流量json',
  `create_person` char(64) DEFAULT NULL COMMENT '创建人',
  `status` int DEFAULT NULL COMMENT '状态（0：编制完成1：运行中 2：运行完成  3：终止）'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='降雨运行方案';

-- ----------------------------
-- Records of bis_xnjmode_project2
-- ----------------------------
BEGIN;
INSERT INTO `bis_xnjmode_project2` (`id`, `rcode`, `pname`, `stcd_r`, `create_date`, `pstart_time`, `pend_time`, `parms`, `rstart_time`, `rend_time`, `max_q`, `max_q_time`, `result`, `stct_r_json`, `create_person`, `status`) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `bis_xnjmode_project2` (`id`, `rcode`, `pname`, `stcd_r`, `create_date`, `pstart_time`, `pend_time`, `parms`, `rstart_time`, `rend_time`, `max_q`, `max_q_time`, `result`, `stct_r_json`, `create_person`, `status`) VALUES ('114393196435476480', 'sjh', '12阿斯顿', '605HQ014', '2024-11-11 23:57:43', NULL, '2024-07-16 10:00:00', '{\"start-time\":\"2024-07-16 01:00:00\",\"end-time\":\"2024-07-16 10:00:00\",\"callback\":\"http://localhost:8080/call_back/callback\",\"step-len\":\"60\",\"xajpara\":[],\"psparms\":{\"nunms\":1,\"ilf\":2.0,\"iw\":3.0,\"iwdr\":4.0,\"nop\":5,\"glf\":6,\"mni\":7},\"areainfo\":[{\"id\":1,\"stcd\":\"605HQ014\",\"name\":\"塘坝\",\"areas\":64.084,\"rate\":0.1300,\"lhcsd\":0,\"lhcs\":0},{\"id\":2,\"stcd\":\"605HQ014\",\"name\":\"双滕\",\"areas\":71.723,\"rate\":0.1462,\"lhcsd\":0,\"lhcs\":1},{\"id\":3,\"stcd\":\"605HQ014\",\"name\":\"筠连\",\"areas\":56.508,\"rate\":0.1152,\"lhcsd\":0,\"lhcs\":3},{\"id\":4,\"stcd\":\"605HQ014\",\"name\":\"木映\",\"areas\":61.517,\"rate\":0.1254,\"lhcsd\":0,\"lhcs\":2},{\"id\":5,\"stcd\":\"605HQ014\",\"name\":\"羊田\",\"areas\":30.697,\"rate\":0.0626,\"lhcsd\":0,\"lhcs\":1},{\"id\":6,\"stcd\":\"605HQ014\",\"name\":\"陈村\",\"areas\":86.325,\"rate\":0.1759,\"lhcsd\":0,\"lhcs\":3},{\"id\":7,\"stcd\":\"605HQ014\",\"name\":\"前丰\",\"areas\":55.745,\"rate\":0.1136,\"lhcsd\":0,\"lhcs\":2},{\"id\":8,\"stcd\":\"605HQ014\",\"name\":\"蕉村\",\"areas\":64.084,\"rate\":0.1306,\"lhcsd\":0,\"lhcs\":2}],\"rains\":[{\"time\":\"2024-07-16 01:00:00\",\"mq\":\"0\",\"erate\":0.075,\"stcdinfo\":[]},{\"time\":\"2024-07-16 02:00:00\",\"mq\":\"0\",\"erate\":0.078,\"stcdinfo\":[]},{\"time\":\"2024-07-16 03:00:00\",\"mq\":\"0\",\"erate\":0.035,\"stcdinfo\":[]},{\"time\":\"2024-07-16 04:00:00\",\"mq\":\"0\",\"erate\":0.066,\"stcdinfo\":[]},{\"time\":\"2024-07-16 05:00:00\",\"mq\":\"0\",\"erate\":0.079,\"stcdinfo\":[]},{\"time\":\"2024-07-16 06:00:00\",\"mq\":\"0\",\"erate\":0.079,\"stcdinfo\":[]},{\"time\":\"2024-07-16 07:00:00\",\"mq\":\"0\",\"erate\":0.081,\"stcdinfo\":[]},{\"time\":\"2024-07-16 08:00:00\",\"mq\":\"0\",\"erate\":0.062,\"stcdinfo\":[]},{\"time\":\"2024-07-16 09:00:00\",\"mq\":\"0\",\"erate\":0.079,\"stcdinfo\":[]},{\"time\":\"2024-07-16 10:00:00\",\"mq\":\"0\",\"erate\":0.047,\"stcdinfo\":[]}]}', NULL, NULL, NULL, NULL, '{\n    \"areainfo\": [\n        {\n            \"areas\": \"35.2\",\n            \"id\": \"1\",\n            \"lhcs\": \"0\",\n            \"lhcsd\": \"0\",\n            \"name\": \"点1\",\n            \"rate\": \"0.12 \",\n            \"stcd\": \"stcd1\"\n        },\n        {\n            \"areas\": \"32.5\",\n            \"id\": \"2\",\n            \"lhcs\": \"2\",\n            \"lhcsd\": \"0\",\n            \"name\": \"点2\",\n            \"rate\": \"0.11\",\n            \"stcd\": \"stcd2\"\n        },\n        {\n            \"areas\": \"30.5\",\n            \"id\": \"3\",\n            \"lhcs\": \"4\",\n            \"lhcsd\": \"0\",\n            \"name\": \"点3\",\n            \"rate\": \"0.11\",\n            \"stcd\": \"stcd3\"\n        },\n        {\n            \"areas\": \"36.5\",\n            \"id\": \"4\",\n            \"lhcs\": \"3\",\n            \"lhcsd\": \"0\",\n            \"name\": \"点4\",\n            \"rate\": \"0.13 \",\n            \"stcd\": \"stcd4\"\n        },\n        {\n            \"areas\": \"13.4\",\n            \"id\": \"5\",\n            \"lhcs\": \"4\",\n            \"lhcsd\": \"0\",\n            \"name\": \"点5\",\n            \"rate\": \"0.05 \",\n            \"stcd\": \"stcd5\"\n        },\n        {\n            \"areas\": \"21.1\",\n            \"id\": \"6\",\n            \"lhcs\": \"3\",\n            \"lhcsd\": \"0\",\n            \"name\": \"点6\",\n            \"rate\": \"0.07\",\n            \"stcd\": \"stcd6\"\n        },\n        {\n            \"areas\": \"33.6\",\n            \"id\": \"7\",\n            \"lhcs\": \"5\",\n            \"lhcsd\": \"0\",\n            \"name\": \"点7\",\n            \"rate\": \"0.12\",\n            \"stcd\": \"stcd7\"\n        },\n        {\n            \"areas\": \"25.3\",\n            \"id\": \"8\",\n            \"lhcs\": \"3\",\n            \"lhcsd\": \"0\",\n            \"name\": \"点8\",\n            \"rate\": \"0.09\",\n            \"stcd\": \"stcd8\"\n        },\n        {\n            \"areas\": \"25.6\",\n            \"id\": \"9\",\n            \"lhcs\": \"3\",\n            \"lhcsd\": \"0\",\n            \"name\": \"点9\",\n            \"rate\": \"0.09\",\n            \"stcd\": \"stcd9\"\n        },\n        {\n            \"areas\": \"36.5\",\n            \"id\": \"10\",\n            \"lhcs\": \"4\",\n            \"lhcsd\": \"0\",\n            \"name\": \"点10\",\n            \"rate\": \"0.13 \",\n            \"stcd\": \"stcd10\"\n        }\n    ],\n    \"callback\": \"http://localhost:18080/api/resulet\",\n    \"end-time\": \"2024-10-21 12:00:00\",\n    \"id\": \"3-20241021-0001\",\n    \"model\": \"1\",\n    \"name\": \"中都2024-10-21 100mm降雨\",\n    \"psparms\": {\n        \"glf\": \"2.0\",\n        \"ilf\": \"1.5\",\n        \"iw\": \"1.0\",\n        \"iwdr\": \"0.99\",\n        \"mni\": \"10\",\n        \"nop\": \"10\",\n        \"nunms\": \"13\"\n    },\n    \"result\": [\n        {\n            \"calmq\": \"0\",\n            \"drop\": \"1.089\",\n            \"mq\": \"1.58\",\n            \"stcd\": \"423324\",\n            \"time\": \"2024-10-21 10:00:00\"\n        },\n        {\n            \"calmq\": \"0.0325456\",\n            \"drop\": \"35.64\",\n            \"mq\": \"1.49\",\n            \"stcd\": \"423324\",\n            \"time\": \"2024-10-21 10:00:00\"\n        },\n        {\n            \"calmq\": \"14.9067\",\n            \"drop\": \"0\",\n            \"mq\": \"6.47\",\n            \"stcd\": \"423324\",\n            \"time\": \"2024-10-21 10:00:00\"\n        }\n    ],\n    \"start-time\": \"2024-10-21 12:00:00\",\n    \"step-len\": \"24\",\n    \"xajpara\": {\n        \"cltw\": {\n            \"max\": \"90\",\n            \"min\": \"60\",\n            \"rate\": \"60\"\n        },\n        \"ctw\": {\n            \"max\": \"200\",\n            \"min\": \"120\",\n            \"rate\": \"122.788\"\n        },\n        \"dcsc\": {\n            \"max\": \"0.4\",\n            \"min\": \"0.1\",\n            \"rate\": \"0.1\"\n        },\n        \"dec\": {\n            \"max\": \"0.2\",\n            \"min\": \"0.1\",\n            \"rate\": \"0.164846\"\n        },\n        \"fcdc\": {\n            \"max\": \"1.5\",\n            \"min\": \"1\",\n            \"rate\": \"1.30669\"\n        },\n        \"ogf\": {\n            \"max\": \"1\",\n            \"min\": \"0.9\",\n            \"rate\": \"0.96575\"\n        },\n        \"pia\": {\n            \"max\": \"0.4\",\n            \"min\": \"0.01\",\n            \"rate\": \"0.01\"\n        },\n        \"rcfr\": {\n            \"max\": \"0.3\",\n            \"min\": \"0\",\n            \"rate\": \"0.143666\"\n        },\n        \"rcfs\": {\n            \"max\": \"1\",\n            \"min\": \"0.7\",\n            \"rate\": \"0.720955\"\n        },\n        \"uctw\": {\n            \"max\": \"20\",\n            \"min\": \"10\",\n            \"rate\": \"14.7147\"\n        },\n        \"ugo\": {\n            \"max\": \"0.6\",\n            \"min\": \"0.3\",\n            \"rate\": \"0.53434\"\n        },\n        \"zsfxxs\": {\n            \"max\": \"1.5\",\n            \"min\": \"0.1\",\n            \"rate\": \"0.856209\"\n        },\n        \"zysrl\": {\n            \"max\": \"80\",\n            \"min\": \"10\",\n            \"rate\": \"11.8791\"\n        }\n    }\n}', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for floodmap_site
-- ----------------------------
DROP TABLE IF EXISTS `floodmap_site`;
CREATE TABLE `floodmap_site` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '编码',
  `lng` float NOT NULL COMMENT '中心点经度',
  `lat` float NOT NULL COMMENT '中心点纬度',
  `last_modified_by` varchar(65) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '最近修改人',
  `last_modified_date` datetime NOT NULL COMMENT '最近修改时间',
  `created_by` varchar(65) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '创建者',
  `created_date` datetime NOT NULL COMMENT '创建时间',
  `version` bigint DEFAULT NULL COMMENT '版本',
  `is_deleted` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除标识',
  `is_river` tinyint DEFAULT '1' COMMENT '是否为河流0否1是',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10004 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='站点、河流';

-- ----------------------------
-- Records of floodmap_site
-- ----------------------------
BEGIN;
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (1, '泥溪镇', NULL, 104.29, 28.98, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 1, 0);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (2, '南溪区', NULL, 104.97, 28.85, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 1, 0);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (3, '三江', NULL, 104.63, 28.77, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (4, '江安县', NULL, 105.07, 28.73, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 1, 0);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (5, '横江', NULL, 104.35, 28.56, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (6, '宋江河', 'sjh', 104.51, 28.16, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (8, '洛亥河', NULL, 104.93, 27.99, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (9, '西宁河', NULL, 103.77, 28.66, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (10, '中都河', NULL, 103.85, 28.78, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (11, '镇溪河', NULL, 104.682, 29.1516, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (13, '长宁河', NULL, 104.96, 28.66, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (14, '南广河', NULL, 104.84, 28.06, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (15, '二夹河', NULL, 104.47, 28.37, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (16, '黄沙河', NULL, 104.82, 28.93, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (17, '越溪河', NULL, 104.3, 29.23, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (18, '古宋河', NULL, 105.29, 28.26, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (19, '龙溪河', NULL, 104.14, 29.03, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (20, '巡司河', NULL, 104.64, 28.18, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (21, '镇舟河', NULL, 104.71, 27.97, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (22, '清溪河', NULL, 104.72, 28.52, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (23, '毓秀河', NULL, 104.93, 28.14, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (24, '贡溪河', NULL, 104.46, 28.49, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (25, '绵溪河', NULL, 105.04, 28.61, '1', '2023-04-21 16:06:00', '1', '2023-04-21 16:06:00', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (26, '晏江河', NULL, 105.1, 28.33, '1', '2023-06-07 10:41:08', '1', '2023-06-07 10:41:11', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (27, '乔巴河', NULL, 104.5, 29.03, '1', '2023-06-14 09:27:14', '1', '2023-06-14 09:27:20', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (28, '久桥河', NULL, 105.09, 28.93, '1', '2023-06-14 09:28:18', '1', '2023-06-14 09:28:24', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (33, '三江-新', '', 104.63, 28.77, '1', '2024-07-23 09:11:21', '1', '2024-07-23 09:11:27', NULL, 1, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (10001, '长江', NULL, 105.07, 28.74, '1', '2023-06-27 09:21:17', '1', '2023-06-27 09:21:22', NULL, 0, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (10002, '岷江', NULL, 104.34, 28.84, '1', '2023-06-27 09:23:02', '1', '2023-06-27 09:23:06', NULL, 1, 1);
INSERT INTO `floodmap_site` (`id`, `name`, `code`, `lng`, `lat`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`, `version`, `is_deleted`, `is_river`) VALUES (10003, '金沙江', NULL, 104.63, 28.77, '1', '2023-09-21 17:23:34', '1', '2023-09-21 17:23:38', NULL, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for floodmap_station_propagate
-- ----------------------------
DROP TABLE IF EXISTS `floodmap_station_propagate`;
CREATE TABLE `floodmap_station_propagate` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `arrive_long` decimal(19,4) DEFAULT NULL COMMENT '上个站点到本站点的距离',
  `parent_id` bigint DEFAULT NULL,
  `arrive_time` decimal(19,4) DEFAULT NULL COMMENT '上个站点到本站点的时间',
  `station_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `station_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `five_z` decimal(19,4) NOT NULL,
  `five_q` decimal(19,4) NOT NULL,
  `ten_z` decimal(19,4) NOT NULL,
  `ten_q` decimal(19,4) NOT NULL,
  `twenty_z` decimal(19,4) NOT NULL,
  `twenty_q` decimal(19,4) NOT NULL,
  `fifty_z` decimal(19,4) NOT NULL,
  `fifty_q` decimal(19,4) NOT NULL,
  `hundred_z` decimal(19,4) NOT NULL,
  `hundred_q` decimal(19,4) NOT NULL,
  `river_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `datum` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `river_id` bigint NOT NULL,
  `section` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `is_del` tinyint NOT NULL DEFAULT '0',
  `last_modified_by` varchar(65) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '最近修改人',
  `last_modified_date` datetime NOT NULL COMMENT '最近修改时间',
  `created_by` varchar(65) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '创建者',
  `created_date` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of floodmap_station_propagate
-- ----------------------------
BEGIN;
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (1, NULL, NULL, NULL, '6045Q027', '横江', 292.6000, 4600.0000, 294.8700, 5990.0000, 296.9900, 7410.0000, 299.6200, 9320.0000, 301.5500, 10800.0000, '横江', '黄海', 5, 'HJ-26', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (2, NULL, NULL, NULL, '60505500', '金坪', 279.1600, 550.0000, 280.2400, 706.0000, 281.1700, 856.0000, 282.2000, 1050.0000, 282.9400, 1190.0000, '黄沙河', '黄海', 16, 'HSH-116', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (3, NULL, NULL, NULL, '605HQ007', '黄沙', 277.3300, 701.0000, 276.1300, 910.0000, 274.8400, 1100.0000, 273.8200, 1340.0000, 272.4700, 1520.0000, '黄沙河', '黄海', 16, 'HSH-170', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (4, NULL, 0, NULL, '60504950', '孝儿', 361.0700, 1970.0000, 362.1500, 2320.0000, 363.1000, 2650.0000, 364.2600, 3060.0000, 365.8400, 3360.0000, '南广河', '黄海', 14, NULL, 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (5, 90.0000, 4, 8.0000, '60505000', '福溪', 285.4400, 2880.0000, 286.6900, 3430.0000, 287.7800, 3930.0000, 289.1200, 4570.0000, 290.0100, 5040.0000, '南广河', '黄海', 14, NULL, 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (6, 1.9000, 8, 0.5000, '605HQ009', '草鞋店', 363.8700, 230.0000, 364.2700, 322.0000, 364.9900, 414.0000, 365.2900, 469.0000, 365.6000, 538.0000, '古宋河', '黄海', 18, 'CS142', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (7, 11.5000, 6, 1.5000, '6051034Q', '兴文', 323.5900, 425.0000, 323.9100, 586.0000, 324.9400, 757.0000, 325.8700, 869.0000, 326.3600, 987.0000, '古宋河', '黄海', 18, 'CS79', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (8, NULL, 0, NULL, '605HQ008', '古宋', 374.3200, 187.0000, 374.8100, 260.0000, 375.7200, 333.0000, 376.1600, 377.0000, 376.4500, 432.0000, '古宋河', '黄海', 18, 'CS166', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (9, NULL, 0, NULL, '6045Q013', '屏边', 579.2800, 1100.0000, 580.1000, 1410.0000, 580.8200, 1700.0000, 581.8400, 2080.0000, 582.6600, 2400.0000, '西宁河', '黄海', 9, 'XNH-61', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (10, NULL, NULL, NULL, '6045Q018', '清平', 556.6000, 1280.0000, 557.5500, 1630.0000, 558.4100, 1970.0000, 559.3600, 2080.0000, 560.0900, 2780.0000, '西宁河', '黄海', 9, 'XNH-51', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (11, NULL, 0, NULL, '6051011Q', '双河', 625.5000, 505.0000, 626.4500, 677.0000, 627.3200, 853.0000, 628.3600, 1090.0000, 629.0900, 1280.0000, '中都河', '黄海', 10, 'ZDH-80', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (12, 12.5000, 11, 1.0000, '604HQ001', '中都', 513.4500, 565.0000, 513.9900, 760.0000, 514.4300, 959.0000, 514.8500, 1230.0000, 515.1500, 1440.0000, '中都河', '黄海', 10, 'ZDH-49', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (13, NULL, 0, NULL, '606HQ002', '合什', 316.3400, 830.0000, 317.3600, 1020.0000, 319.0700, 1190.0000, 320.1400, 1420.0000, 321.0500, 1580.0000, '越溪河', '黄海', 17, 'YXH-205', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (14, 18.6000, 15, 2.5000, '6051004Q', '隆兴', 304.6100, 1160.0000, 306.0000, 1430.0000, 307.0500, 1680.0000, 308.2900, 1970.0000, 309.1800, 2210.0000, '越溪河', '黄海', 17, 'YXH-84', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (15, 37.0000, 13, 5.0000, '60607500', '观音', 300.4400, 1220.0000, 301.4400, 1480.0000, 301.4400, 1730.0000, 302.3200, 2060.0000, 303.4000, 2300.0000, '越溪河', '黄海', 17, 'YXH-48', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (16, NULL, NULL, NULL, '605HQ005', '红桥', 329.6800, 177.0000, 330.3800, 242.0000, 331.0400, 308.0000, 331.8000, 396.0000, 332.3200, 464.0000, '晏江河', '黄海', 26, 'YJH-64', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (17, NULL, NULL, NULL, '6051012Q', '底蓬', 258.2000, 504.0000, 259.8800, 700.0000, 261.2600, 901.0000, 262.8500, 1170.0000, 264.0100, 1380.0000, '绵溪河', '黄海', 25, 'MXH-160', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (18, NULL, NULL, NULL, '605HQ013', '可久', 340.8400, 332.0000, 341.6700, 468.0000, 342.4300, 610.0000, 343.3300, 803.0000, 343.9600, 953.0000, '二夹河', '黄海', 15, 'ejh47', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (19, NULL, NULL, NULL, '605HQ012', '洛亥', 433.0400, 311.0000, 433.8800, 440.0000, 434.6900, 575.0000, 435.6500, 759.0000, 436.3500, 902.0000, '洛亥河', '黄海', 8, 'CS49', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (20, 11.5000, 21, 1.0000, '605HQ011', '维新', 409.9500, 318.0000, 410.7700, 445.0000, 411.4800, 577.0000, 412.2300, 758.0000, 412.7500, 899.0000, '镇舟河', '黄海', 21, 'zzh31', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (21, NULL, 0, NULL, '605HQ006', '镇舟', 455.3300, 256.0000, 456.0700, 358.0000, 456.6900, 463.0000, 457.4700, 608.0000, 458.0700, 721.0000, '镇舟河', '黄海', 21, 'zzh82', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (22, 37.5000, 23, 2.0000, '605HQ014', '罗场', 318.4900, 425.0000, 318.7300, 586.0000, 319.5600, 757.0000, 320.3200, 869.0000, 320.7300, 987.0000, '宋江河', '黄海', 6, 'CS71', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (23, NULL, 0, NULL, '605HQ003', '塘坝', 438.3100, 117.0000, 438.6100, 154.0000, 439.0000, 192.0000, 439.6200, 213.0000, 439.9200, 241.0000, '宋江河', '黄海', 6, 'CS217', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (24, NULL, NULL, NULL, '605HQ002', '元田', 365.1700, 257.0000, 365.8700, 359.0000, 366.2200, 464.0000, 366.7200, 608.0000, 367.0800, 720.0000, '清溪河', '黄海', 11, 'CS122', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (25, NULL, NULL, NULL, '605HQ004', '珙县', 391.0500, 224.0000, 391.5600, 309.0000, 392.0500, 397.0000, 392.6400, 517.0000, 393.3400, 610.0000, '清溪河', '黄海', 11, 'CS154', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (26, NULL, NULL, NULL, '605HQ015', '沙河', 355.3500, 420.0000, 356.2500, 584.0000, 356.9200, 753.0000, 357.4300, 983.0000, 357.8000, 1160.0000, '清溪河', '黄海', 11, 'CS97', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (27, NULL, NULL, NULL, '605HQ010', '白凡滩', 386.8200, 506.0000, 387.9300, 754.0000, 388.8600, 1020.0000, 389.8800, 1388.0000, 390.8000, 1676.0000, '巡司河', '黄海', 20, 'XSH3+141', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (28, NULL, NULL, NULL, '606HQ001', '龙溪', 507.6000, 493.0000, 508.1800, 603.0000, 508.6600, 711.0000, 509.1700, 853.0000, 509.6100, 958.0000, '龙溪河', '黄海', 19, 'LXH1-60', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (29, NULL, NULL, NULL, '6051007Q', '古河', 258.6784, 2300.0000, 260.2677, 2840.0000, 261.5307, 3380.0000, 262.9805, 4070.0000, 264.0803, 4560.0000, '长宁河', '黄海', 13, 'cnh253', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (30, NULL, NULL, NULL, '605HQ001', '三江湖', 282.1795, 1640.0000, 283.5106, 2090.0000, 284.6378, 2480.0000, 285.5235, 2980.0000, 286.3761, 3370.0000, '长宁河', '黄海', 13, 'cnh186', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (31, NULL, NULL, NULL, '60505750', '长宁', 263.8983, 1860.0000, 265.0445, 2370.0000, 265.9347, 2810.0000, 266.9888, 3370.0000, 267.7556, 3820.0000, '长宁河', '黄海', 13, 'cnh222', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (32, NULL, NULL, NULL, '6051006Q', '珙泉', 354.1902, 717.0000, 354.4874, 885.0000, 355.3894, 1050.0000, 355.8396, 1266.0000, 356.0008, 1416.0000, '长宁河', '黄海', 13, 'cnh75', 0, '1', '2023-06-13 16:29:15', '1', '2023-06-13 16:29:15');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (46, NULL, 0, NULL, '6051023Q', '月波', 307.4000, 23800.0000, 308.6700, 28500.0000, 309.8200, 33100.0000, 311.2700, 38900.0000, 312.3700, 43300.0000, '长江', '85基准基面', 10001, '', 0, '1', '2023-06-27 09:29:56', '1', '2023-06-27 09:29:56');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (47, 10.0000, 46, 0.7000, '6051026Q', '泥溪', 301.6300, 23900.0000, 303.1600, 28600.0000, 304.3700, 33300.0000, 305.7500, 39100.0000, 306.7100, 43500.0000, '岷江', '85基准基面', 10002, '', 0, '1', '2023-06-27 09:34:28', '1', '2023-06-27 09:34:28');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (48, 9.8000, 47, 0.7000, '6051027Q', '古柏', 296.8400, 23900.0000, 298.2400, 28700.0000, 299.5000, 33300.0000, 301.0000, 39100.0000, 302.0200, 43500.0000, '岷江', '85基准基面', 10002, '', 0, '1', '2023-06-27 09:40:40', '1', '2023-06-27 09:40:40');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (49, 5.7000, 48, 0.5000, '6051024Q', '蕨溪', 294.8000, 24000.0000, 296.2500, 28700.0000, 297.5700, 33300.0000, 299.0200, 39100.0000, 300.0200, 43600.0000, '岷江', '85基准基面', 10002, '', 0, '1', '2023-06-27 09:42:46', '1', '2023-06-27 09:42:46');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (50, 12.0000, 49, 1.0000, '606HQ006', '屏山城区', 288.2300, 24000.0000, 290.1400, 28700.0000, 291.9500, 33400.0000, 294.0200, 39200.0000, 295.5000, 43600.0000, '岷江', '85基准基面', 10002, '', 0, '1', '2023-06-27 09:44:38', '1', '2023-06-27 09:44:38');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (51, NULL, NULL, NULL, '6065028Q', '思坡', 280.2200, 24300.0000, 281.5000, 29200.0000, 282.6400, 33900.0000, 284.0200, 39800.0000, 284.9700, 44300.0000, '岷江', '85基准基面', 10002, '', 0, '1', '2023-06-27 09:49:29', '1', '2023-06-27 09:49:29');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (52, NULL, NULL, NULL, '6051029Q', '江南', 259.6200, 40400.0000, 261.1300, 45800.0000, 262.4400, 50900.0000, 264.0200, 57200.0000, 265.1700, 61800.0000, '长江', '85基准基面', 10001, '', 0, '1', '2023-06-27 09:50:37', '1', '2023-06-27 09:50:37');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (53, NULL, NULL, NULL, '6051031Q', '江安', 254.8000, 40400.0000, 256.1600, 45900.0000, 257.4000, 51000.0000, 258.8300, 57300.0000, 259.8800, 61900.0000, '长江', '85基准基面', 10001, '', 0, '1', '2023-06-27 09:51:53', '1', '2023-06-27 09:51:53');
INSERT INTO `floodmap_station_propagate` (`id`, `arrive_long`, `parent_id`, `arrive_time`, `station_code`, `station_name`, `five_z`, `five_q`, `ten_z`, `ten_q`, `twenty_z`, `twenty_q`, `fifty_z`, `fifty_q`, `hundred_z`, `hundred_q`, `river_name`, `datum`, `river_id`, `section`, `is_del`, `last_modified_by`, `last_modified_date`, `created_by`, `created_date`) VALUES (54, NULL, NULL, NULL, '6051032Q', '井口', 249.3700, 40500.0000, 250.7200, 45900.0000, 252.0000, 51000.0000, 253.5400, 57300.0000, 254.5400, 61900.0000, '长江', '85基准基面', 10001, '', 0, '1', '2023-06-27 09:52:48', '1', '2023-06-27 09:52:48');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint NOT NULL COMMENT 'ID',
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `password`, `email`) VALUES (1232123, '张三', '123123', '11@qq.com');
INSERT INTO `user` (`id`, `username`, `password`, `email`) VALUES (23787323, '王五', '111111', '33@qq.com');
INSERT INTO `user` (`id`, `username`, `password`, `email`) VALUES (3121231231, '李四', '123321', '22@qq.com');
INSERT INTO `user` (`id`, `username`, `password`, `email`) VALUES (111767628934156288, '赵六', '111111', '44@qq.com');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
